Hello,

We have Windows 2008 r2 TS, on which we have MS office 2007 Standard installed. There are almost 50 users on this particular machine.

The problem is we get an error message when we try to open a .txt file in Excel (Right click on .txt file--> Open with --> Excel). Error message is as follows  "this action is valid for the products which are currently installed". Previously this was faced by all users so we completely reinstalled it, which worked, except for 1 user.  Currently i have recreated the profile for that particular user but that also didn't helped.

A drag-drop approach works but user don't want it that way.  

Now am clueless in terms of where should i look into. Any help would really be helpful.

Thanks,

Amol S

Hi Amol S,

According to your error message, this issue may occur if you have a corrupted shortcut to the Office program that you are trying to start. There are 2 methods you can try.

Method 1:

Run the Detect and Repair tool to restore your broken shortcuts. To do this, follow these steps:

1. On the Help menu, click Detect and Repair. (Make sure that the Restore my shortcuts while repairing check box is selected.)
2. Click Start.

Method 2:

Use the Create Shortcut wizard. To do this, follow these steps:

1. Quit all Office programs.
2. Right-click a blank area on your desktop, point to New, and then click Shortcut.
3. In the Create Shortcut wizard, click Browse, and then locate the Office program. By default, Office programs are installed at the following location:
   C:\Program Files\Microsoft Office\OFFICE Version Number
4. Click the Office program that you are trying to start. For example, click Excel.
5. Click Next, and then click Finish.
6. A new shortcut to the Office program is created on the desktop.
7. Click the newly created shortcut icon, and then hold down the right mouse button.
8. Drag the shortcut icon while you hold down the right mouse button, point to Start, point to Programs, point to Microsoft Office, and then drop the shortcut icon.

Quote from: https://support.microsoft.com/en-us/kb/907342

Hope it is helpful, and I am glad to help and forward to your reply.

Best regards,

• Edited by guGuuuMy 17 hours 24 minutes ago

Hi Amol S,

According to your error message, this issue may occur if you have a corrupted shortcut to the Office program that you are trying to start. There are 2 methods you can try.

Method 1:

Run the Detect and Repair tool to restore your broken shortcuts. To do this, follow these steps:

1. On the Help menu, click Detect and Repair. (Make sure that the Restore my shortcuts while repairing check box is selected.)
2. Click Start.

Method 2:

Use the Create Shortcut wizard. To do this, follow these steps:

1. Quit all Office programs.
2. Right-click a blank area on your desktop, point to New, and then click Shortcut.
3. In the Create Shortcut wizard, click Browse, and then locate the Office program. By default, Office programs are installed at the following location:
   C:\Program Files\Microsoft Office\OFFICE Version Number
4. Click the Office program that you are trying to start. For example, click Excel.
5. Click Next, and then click Finish.
6. A new shortcut to the Office program is created on the desktop.
7. Click the newly created shortcut icon, and then hold down the right mouse button.
8. Drag the shortcut icon while you hold down the right mouse button, point to Start, point to Programs, point to Microsoft Office, and then drop the shortcut icon.

Quote from: https://support.microsoft.com/en-us/kb/907342

Hope it is helpful, and I am glad to help and forward to your reply.

Best regards,

• Edited by guGuuuMy Wednesday, April 15, 2015 2:03 PM

Hi Amol S,

According to your error message, this issue may occur if you have a corrupted shortcut to the Office program that you are trying to start. There are 2 methods you can try.

Method 1:

Run the Detect and Repair tool to restore your broken shortcuts. To do this, follow these steps:

1. On the Help menu, click Detect and Repair. (Make sure that the Restore my shortcuts while repairing check box is selected.)
2. Click Start.

Method 2:

Use the Create Shortcut wizard. To do this, follow these steps:

1. Quit all Office programs.
2. Right-click a blank area on your desktop, point to New, and then click Shortcut.
3. In the Create Shortcut wizard, click Browse, and then locate the Office program. By default, Office programs are installed at the following location:
   C:\Program Files\Microsoft Office\OFFICE Version Number
4. Click the Office program that you are trying to start. For example, click Excel.
5. Click Next, and then click Finish.
6. A new shortcut to the Office program is created on the desktop.
7. Click the newly created shortcut icon, and then hold down the right mouse button.
8. Drag the shortcut icon while you hold down the right mouse button, point to Start, point to Programs, point to Microsoft Office, and then drop the shortcut icon.

Quote from: https://support.microsoft.com/en-us/kb/907342

Hope it is helpful, and I am glad to help and forward to your reply.

Best regards,

• Edited by guGuuuMy Wednesday, April 15, 2015 2:03 PM

Hi Amol S,

According to your error message, this issue may occur if you have a corrupted shortcut to the Office program that you are trying to start. There are 2 methods you can try.

Method 1:

Run the Detect and Repair tool to restore your broken shortcuts. To do this, follow these steps:

1. On the Help menu, click Detect and Repair. (Make sure that the Restore my shortcuts while repairing check box is selected.)
2. Click Start.

Method 2:

Use the Create Shortcut wizard. To do this, follow these steps:

1. Quit all Office programs.
2. Right-click a blank area on your desktop, point to New, and then click Shortcut.
3. In the Create Shortcut wizard, click Browse, and then locate the Office program. By default, Office programs are installed at the following location:
   C:\Program Files\Microsoft Office\OFFICE Version Number
4. Click the Office program that you are trying to start. For example, click Excel.
5. Click Next, and then click Finish.
6. A new shortcut to the Office program is created on the desktop.
7. Click the newly created shortcut icon, and then hold down the right mouse button.
8. Drag the shortcut icon while you hold down the right mouse button, point to Start, point to Programs, point to Microsoft Office, and then drop the shortcut icon.

Quote from: https://support.microsoft.com/en-us/kb/907342

Hope it is helpful, and I am glad to help and forward to your reply.

Best regards,

• Edited by guGuuuMy Wednesday, April 15, 2015 2:03 PM

Hi Amol S,

According to your error message, this issue may occur if you have a corrupted shortcut to the Office program that you are trying to start. There are 2 methods you can try.

Method 1:

Run the Detect and Repair tool to restore your broken shortcuts. To do this, follow these steps:

1. On the Help menu, click Detect and Repair. (Make sure that the Restore my shortcuts while repairing check box is selected.)
2. Click Start.

Method 2:

Use the Create Shortcut wizard. To do this, follow these steps:

1. Quit all Office programs.
2. Right-click a blank area on your desktop, point to New, and then click Shortcut.
3. In the Create Shortcut wizard, click Browse, and then locate the Office program. By default, Office programs are installed at the following location:
   C:\Program Files\Microsoft Office\OFFICE Version Number
4. Click the Office program that you are trying to start. For example, click Excel.
5. Click Next, and then click Finish.
6. A new shortcut to the Office program is created on the desktop.
7. Click the newly created shortcut icon, and then hold down the right mouse button.
8. Drag the shortcut icon while you hold down the right mouse button, point to Start, point to Programs, point to Microsoft Office, and then drop the shortcut icon.

Quote from: https://support.microsoft.com/en-us/kb/907342

Hope it is helpful, and I am glad to help and forward to your reply.

Best regards,

• Edited by guGuuuMy Wednesday, April 15, 2015 2:03 PM

Hey guGuuMy,

Thanks for  the reply, i tried as you suggested but it didn't helped, still have the same error. Even tried this doing this from different user profile. Anything else i can look into.

Regards,

Amol S

Hello,

Is there any chance that any Add-ins responsible for this?

Regards,

Amol S

Hi Amol S

Does it work fine without opening the .txt file?

As your said, you think perhaps any add-ins responsible for this issue. Remove add-ins from excel and try again.

Remove add-ins in excel 2007:

https://support.office.com/en-us/article/Enable-or-disable-add-ins-in-Office-programs-3e533d0f-a6cf-44b7-b6b4-3d9185b5e025

And finally you can try to perform a clean boot in Windows.

https://support.microsoft.com/en-us/kb/331796

This helps eliminate software conflicts that occur when you install a program or an update or when you run a program in Windows. You may find what conflict is causing the problem by performing a clean boot.

Regards,

Emi

• Edited by guGuuuMy 22 hours 16 minutes ago

Hello,

I disabled all Add-ins but that also didn't worked. Just now i have discovered some difference in .dll files in the affected system, seems these .dll files are not registered, reason is unknown. Can you help me on how can  i register all of these .dll files. May be this might resolve the issue. Any more suggestion are also welcomed. Thanks

Regards,

Amol S

Hi Amol S

Does it work fine without opening the .txt file?

As your said, you think perhaps any add-ins responsible for this issue. Remove add-ins from excel and try again.

Remove add-ins in excel 2007:

https://support.office.com/en-us/article/Enable-or-disable-add-ins-in-Office-programs-3e533d0f-a6cf-44b7-b6b4-3d9185b5e025

And finally you can try to perform a clean boot in Windows.

https://support.microsoft.com/en-us/kb/331796

This helps eliminate software conflicts that occur when you install a program or an update or when you run a program in Windows. You may find what conflict is causing the problem by performing a clean boot.

Regards,

Emi

• Edited by guGuuuMy Thursday, April 16, 2015 9:14 AM

Hi Amol S

Does it work fine without opening the .txt file?

As your said, you think perhaps any add-ins responsible for this issue. Remove add-ins from excel and try again.

Remove add-ins in excel 2007:

https://support.office.com/en-us/article/Enable-or-disable-add-ins-in-Office-programs-3e533d0f-a6cf-44b7-b6b4-3d9185b5e025

And finally you can try to perform a clean boot in Windows.

https://support.microsoft.com/en-us/kb/331796

This helps eliminate software conflicts that occur when you install a program or an update or when you run a program in Windows. You may find what conflict is causing the problem by performing a clean boot.

Regards,

Emi

• Edited by guGuuuMy Thursday, April 16, 2015 9:14 AM

Hi Amol S

Does it work fine without opening the .txt file?

As your said, you think perhaps any add-ins responsible for this issue. Remove add-ins from excel and try again.

Remove add-ins in excel 2007:

https://support.office.com/en-us/article/Enable-or-disable-add-ins-in-Office-programs-3e533d0f-a6cf-44b7-b6b4-3d9185b5e025

And finally you can try to perform a clean boot in Windows.

https://support.microsoft.com/en-us/kb/331796

This helps eliminate software conflicts that occur when you install a program or an update or when you run a program in Windows. You may find what conflict is causing the problem by performing a clean boot.

Regards,

Emi

• Edited by guGuuuMy Thursday, April 16, 2015 9:14 AM

Hi Amol S,

As per the description, I understand that you are trying to register .dll files in your computer now.

I suggest you to go through the following article to know more about registering .dll file.

Refer to the Link:

https://support2.microsoft.com/kb/844592?wa=wsignin1.0

Unregister or Register DLL or OCX files:

The Regsvr32 tool is a command-line utility that can be used for registering and un-registering OLE controls like DLL and ActiveX (OCX) controls in the Windows operating system. If you find that some of your Windows functions are note working properly, you may need to register your dll files.

Register dll file

To register a dll or ocx file, open a command prompt windows as an administrator, type the following and hit Enter:

regsvr32 path & filename of dllor ocx

Unregister dll file

To un-register a dll or ocx file, open a command prompt windows as an administrator, type the following and hit Enter:

regsvr32 /u path & filename of dllor ocx

Note: This will register or unregister the dll file.

Hope this information is helpful. Please do let us know if you need further assistance, Ill be glad to assist you.

Regard,

Hi Amol S,

As per the description, I understand that you are trying to register .dll files in your computer now.

I suggest you to go through the following article to know more about registering .dll file.

Refer to the Link:

https://support2.microsoft.com/kb/844592?wa=wsignin1.0

Unregister or Register DLL or OCX files:

The Regsvr32 tool is a command-line utility that can be used for registering and un-registering OLE controls like DLL and ActiveX (OCX) controls in the Windows operating system. If you find that some of your Windows functions are note working properly, you may need to register your dll files.

Register dll file

To register a dll or ocx file, open a command prompt windows as an administrator, type the following and hit Enter:

regsvr32 path & filename of dllor ocx

Unregister dll file

To un-register a dll or ocx file, open a command prompt windows as an administrator, type the following and hit Enter:

regsvr32 /u path & filename of dllor ocx

Note: This will register or unregister the dll file.

Hope this information is helpful. Please do let us know if you need further assistance, Ill be glad to assist you.

Regard,

• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Tuesday, April 21, 2015 2:58 AM
• Marked as answer by AmolShinde22 23 hours 56 minutes ago

Hello,

I tried registering those .dll files,  few got registered but many fired an error message "The module (module-name) was loaded but the entry-point DllRegisterServer was not found. Make sure (Module name) is  a valid Dll and ocx file and then try again".

Have no clue why is it happening, any more suggestion/help on this plz as this has been quiet frustrating experience for all users?. Thanks again.